﻿/****** Script for Creating sample source table  ******/
/****** Run this script on AdventureWorksDW2008R2 *****/
SELECT convert(varchar(max),[ProductKey])
      +'/'+[ProductAlternateKey]
      +'/'+[EnglishProductName]
      +'/'+isnull([Color],'')
      +'/'+isnull(convert(varchar(max),[SafetyStockLevel]),'')
      +'/'+isnull(convert(varchar(max),[ReorderPoint]),'')
      +'/'+isnull(convert(varchar(max),[StartDate]),'')
      +'/'+isnull([Status],'')
      into TmpDataTable
  FROM [AdventureWorksDW2008R2].[dbo].[DimProduct]